
-- ----------------------------
-- Table structure for [dbo].[z_png_webform_company]
-- ----------------------------
/* DROP TABLE [dbo].[z_png_webform_company]
GO
CREATE TABLE [dbo].[z_png_webform_company] (
[company_code] nvarchar(255) NOT NULL ,
[long_name] nvarchar(255) NOT NULL ,
[short_name] nvarchar(255) NULL ,
[city] nvarchar(60) NULL ,
[country] nvarchar(60) NULL ,
[country_name] nvarchar(255) NULL 
)


GO */

-- ----------------------------
-- Records of z_png_webform_company
-- ----------------------------
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'255', N'PROCTER & GAMBLE AUSTRALIA PTY LTD', N'P&G Australia Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO

INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'767', N'PROCTER & GAMBLE PET CARE (AUSTRALIA) PTY LTD', N'P&G Pet Care (AU) Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'854', N'GILLETTE AUSTRALIA PTY LTD', N'Gillette Australia Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2213', N'COSMETIC SUPPLIERS PTY LTD', N'Cosmetic Supp. Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2214', N'PPS HAIRWEAR AUSTRALIA PTY LTD ', N'PPS Hairwear AU Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2219', N'GRESHAM COSMETICS PTY LTD', N'Gresham Cosmetics Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2237', N'COSMETIC PRODUCTS PTY LTD', N'Cosmetic Products Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2322', N'PRINGLES AUSTRALIA PTY LTD', N'Pringles Australia Pty Ltd', N'Sydney', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'392', N'PROCTER & GAMBLE DISTRIBUTING NEW ZEALAND LIMITED', N'P&G Distributing NZ Ltd', N'Auckland', N'AU', N'Australia & New Zealand');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2335', N'NEW ZEALAND PRINGLES CO', N'NZ Pringles CO', N'Auckland', N'AU', N'Australia & New Zealand');
GO
--------------------------
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'404', N'PROCTER AND GAMBLE POLSKA SP.Z O.O.', N'P&G Polska Sp.z o.o.', N'Warsaw', N'PL', N'Poland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'533', N'PROCTER AND GAMBLE OPERATIONS POLSKA SP.Z O.O.', N'P&G Ops Polska Sp.z o.o.', N'Warsaw', N'PL', N'Poland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'978', N'GILLETTE POLAND SA', N'Gillette Poland SA', N'Warsaw', N'PL', N'Poland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2030', N'PROCTER AND GAMBLE DS POLSKA SP. Z O.O.', N'P&G DS Polska Sp.z o.o.', N'Warsaw', N'PL', N'Poland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2031', N'GILLETTE POLAND INTERNATIONAL SP. Z O.O.', N'Gillette PL Intl Sp.z o.o.', N'Lodz', N'PL', N'Poland');
GO
-------------------------------------------
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'430', N'PROCTER & GAMBLE SWITZERLAND SARL', N'P&G Switzerland SARL', N'Geneva', N'CH', N'Switzerland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'700', N'PROCTER & GAMBLE EUROPE SA', N'P&G Europe SA', N'Geneva', N'CH', N'Switzerland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'752', N'PROCTER & GAMBLE SERVICES (SWITZERLAND) SA', N'P&G Services (Switz) SA', N'Geneva', N'CH', N'Switzerland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'800', N'PROCTER & GAMBLE INTERNATIONAL OPERATIONS SA', N'P&G Intl Operations SA', N'Geneva', N'CH', N'Switzerland');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2289', N'PGT HEALTHCARE LLP', N'PGT Healthcare LLP', N'Geneva', N'CH', N'Switzerland');
GO
---------------------------------
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'416', N'ARBORA S.A.', N'ARBORA S.A.', N'Barcelona', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'423', N'PROCTER & GAMBLE MATARO S.L.U.', N'P&G Mataro S.L.U.', N'Alcobendas', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'491', N'ARBORA & AUSONIA, S.L.U.', N'Arbora & Ausonia, S.L.U.', N'Barcelona', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'747', N'PROCTER & GAMBLE ESPANA, S.A.', N'P&G Espana S.A.', N'Alcobendas', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'918', N'LABORATORIOS VICKS, S.L.', N'Laboratorios Vicks, S.L.U.', N'Alcobendas', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'940', N'PROCTER & GAMBLE PRESTIGE PRODUCTS, S.A.U.', N'P&G Prestige Products SAU', N'Alcobendas', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2208', N'PROFESSIONAL CARE LOGISTICS, S.L.U.', N'Prof Care Logistics, S.L.U.', N'Madrid', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2209', N'PRODUCTOS COSMETICOS, S.L.', N'Productos Cosmeticos, S.L.', N'Madrid', N'ES', N'Spain');
GO
INSERT INTO [dbo].[z_png_webform_company] ([company_code], [long_name], [short_name], [city], [country], [country_name]) VALUES (N'2310', N'PRINGLES CRISPS SPAIN SLU', N'Pringles Crisps Spain SLU', N'Alcobendas', N'ES', N'Spain');
GO
